/*
 Navicat MySQL Data Transfer

 Source Server         : 39.100.131.79
 Source Server Type    : MySQL
 Source Server Version : 80017
 Source Host           : 39.100.131.79:3306
 Source Schema         : car_manager

 Target Server Type    : MySQL
 Target Server Version : 80017
 File Encoding         : 65001

 Date: 12/10/2019 08:50:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_car
-- ----------------------------
DROP TABLE IF EXISTS `t_car`;
CREATE TABLE `t_car` (
  `t_car_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆ID主键（uuid）',
  `t_car_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车牌号',
  `t_car_driver_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `t_car_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车辆类型',
  `t_status` int(9) DEFAULT NULL COMMENT '车辆状态 0：执勤 1：封存 2：待命 3：保养 4：在修 5：待修 6：带料 7：待报废 8：保养',
  `t_create_date` datetime DEFAULT NULL COMMENT '新增日期',
  `t_data_status` int(2) DEFAULT NULL COMMENT '数据状态',
  `t_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`t_car_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_car
-- ----------------------------
BEGIN;
INSERT INTO `t_car` VALUES ('117746353165006', 'LW91105', '1177960670621958144', '3', 3, '2019-09-27 14:02:37', 0, NULL);
INSERT INTO `t_car` VALUES ('117746361397166', 'LW91106', '1177965123173449728', '3', 3, '2019-09-27 14:02:56', 0, NULL);
INSERT INTO `t_car` VALUES ('117746372036438', 'LW91107', '1177463720364380161', '6', 3, '2019-09-27 14:03:22', 0, NULL);
INSERT INTO `t_car` VALUES ('117746385035005', 'LW91108', '1177964817186390016', '3', 3, '2019-09-27 14:03:53', 0, NULL);
INSERT INTO `t_car` VALUES ('117746397427915', 'LW91109', '1177968132926308352', '3', 3, '2019-09-27 14:04:22', 0, NULL);
INSERT INTO `t_car` VALUES ('117746416544294', 'LW91110', '1177465813330464769', '6', 3, '2019-09-27 14:05:08', 0, NULL);
INSERT INTO `t_car` VALUES ('117746435127578', 'LW91111', '1178127547435790336', '1', 3, '2019-09-27 14:05:52', 0, NULL);
INSERT INTO `t_car` VALUES ('117746460183092', 'LW91112', '1177464601830920193', '5', 3, '2019-09-27 14:06:52', 0, NULL);
INSERT INTO `t_car` VALUES ('117746484905158', 'LW91113', '1177965123173449728', '2', 3, '2019-09-27 14:07:51', 0, NULL);
INSERT INTO `t_car` VALUES ('117746503369743', 'LW91114', '1177969707426086912', '0', 3, '2019-09-27 14:08:35', 0, NULL);
INSERT INTO `t_car` VALUES ('117746519712848', 'LW91115', '1177590856959221760', '3', 3, '2019-09-27 14:09:14', 0, NULL);
INSERT INTO `t_car` VALUES ('117746552298396', 'LW91116', '1177968412409561088', '3', 3, '2019-09-27 14:10:32', 0, NULL);
INSERT INTO `t_car` VALUES ('117746581333046', 'LW91117', '1177969470292721664', '3', 3, '2019-09-27 14:11:41', 0, NULL);
INSERT INTO `t_car` VALUES ('117746593059062', 'LW91118', '1177464849051586561', '8', 3, '2019-09-27 14:12:09', 0, NULL);
INSERT INTO `t_car` VALUES ('117746606732912', 'LW91119', '1177976658125918208', '6', 3, '2019-09-27 14:12:41', 0, NULL);
INSERT INTO `t_car` VALUES ('117746628625082', 'LW91120', '1177465033697431553', '6', 3, '2019-09-27 14:13:34', 0, NULL);
INSERT INTO `t_car` VALUES ('117746641125366', 'LW91163', '1177465813330464769', '7', 3, '2019-09-27 14:14:03', 0, NULL);
INSERT INTO `t_car` VALUES ('117746655708542', 'LW93163', '1178125321665474560', '9', 3, '2019-09-27 14:14:38', 0, NULL);
INSERT INTO `t_car` VALUES ('117746666706007', 'LW99113', '1178121126816202753', '10', 2, '2019-09-27 14:15:04', 0, NULL);
INSERT INTO `t_car` VALUES ('117746675633583', 'LW99112', '1181430786198204416', '11', 2, '2019-09-27 14:15:26', 0, NULL);
INSERT INTO `t_car` VALUES ('117746686464115', 'LW99114', '1182817501256482816', '12', 2, '2019-09-27 14:15:51', 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_car_status
-- ----------------------------
DROP TABLE IF EXISTS `t_car_status`;
CREATE TABLE `t_car_status` (
  `car_status_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆状态id',
  `status_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态码',
  `status_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态名称',
  PRIMARY KEY (`car_status_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_car_status
-- ----------------------------
BEGIN;
INSERT INTO `t_car_status` VALUES ('1', '1', '在勤');
INSERT INTO `t_car_status` VALUES ('2', '2', '待勤');
INSERT INTO `t_car_status` VALUES ('3', '3', '待命');
COMMIT;

-- ----------------------------
-- Table structure for t_car_type
-- ----------------------------
DROP TABLE IF EXISTS `t_car_type`;
CREATE TABLE `t_car_type` (
  `car_type_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆类型id',
  `type_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆类型编码',
  `type_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆类型名称',
  PRIMARY KEY (`car_type_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_car_type
-- ----------------------------
BEGIN;
INSERT INTO `t_car_type` VALUES ('1', '0', '金杯救护');
INSERT INTO `t_car_type` VALUES ('10', '9', '本田雅阁');
INSERT INTO `t_car_type` VALUES ('11', '10', '江淮客货');
INSERT INTO `t_car_type` VALUES ('12', '11', '东风');
INSERT INTO `t_car_type` VALUES ('13', '12', '衡山大客车');
INSERT INTO `t_car_type` VALUES ('2', '1', '大众帕萨特');
INSERT INTO `t_car_type` VALUES ('3', '2', '全顺');
INSERT INTO `t_car_type` VALUES ('4', '3', '红旗H7');
INSERT INTO `t_car_type` VALUES ('5', '4', '大众');
INSERT INTO `t_car_type` VALUES ('6', '5', '金杯');
INSERT INTO `t_car_type` VALUES ('7', '6', '红旗B70');
INSERT INTO `t_car_type` VALUES ('8', '7', '红旗B90');
INSERT INTO `t_car_type` VALUES ('9', '8', '大众迈腾');
COMMIT;

-- ----------------------------
-- Table structure for t_destination
-- ----------------------------
DROP TABLE IF EXISTS `t_destination`;
CREATE TABLE `t_destination` (
  `t_des_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `t_des_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `t_des_time` datetime DEFAULT NULL,
  `t_data_status` int(10) DEFAULT NULL,
  PRIMARY KEY (`t_des_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_destination
-- ----------------------------
BEGIN;
INSERT INTO `t_destination` VALUES ('1', '京城', '2019-08-24 11:24:51', 1);
INSERT INTO `t_destination` VALUES ('10', '总医院', '2019-09-28 23:04:09', 1);
INSERT INTO `t_destination` VALUES ('2', '花果山', '2019-09-29 10:09:23', 0);
INSERT INTO `t_destination` VALUES ('43994656106', '总医院', '2019-10-08 13:23:28', 0);
INSERT INTO `t_destination` VALUES ('54371995861', '单位', '2019-10-11 14:29:28', 0);
INSERT INTO `t_destination` VALUES ('551491873976320', '明孝陵', '2019-10-11 15:00:21', NULL);
INSERT INTO `t_destination` VALUES ('551492142411776', '明孝陵', '2019-10-11 15:00:21', NULL);
INSERT INTO `t_destination` VALUES ('551492146606080', '明孝陵', '2019-10-11 15:00:21', NULL);
INSERT INTO `t_destination` VALUES ('551492146606081', '明孝陵', '2019-10-11 15:00:21', NULL);
INSERT INTO `t_destination` VALUES ('551492146606082', '明孝陵', '2019-10-11 15:00:21', NULL);
INSERT INTO `t_destination` VALUES ('551492146606083', '明孝陵', '2019-10-11 15:00:21', NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_driver
-- ----------------------------
DROP TABLE IF EXISTS `t_driver`;
CREATE TABLE `t_driver` (
  `t_driver_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '驾驶员id 主键（uuid)',
  `t_drive_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '驾驶员姓名',
  `t_department` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所属部门',
  `t_tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
  `t_card_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证号',
  `t_status` int(3) DEFAULT NULL COMMENT '驾驶员状态 1：空闲 2：任务中 3：休息中',
  `t_data_status` int(2) DEFAULT NULL COMMENT '数据状态',
  `t_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`t_driver_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_driver
-- ----------------------------
BEGIN;
INSERT INTO `t_driver` VALUES ('1177463531650060289', '闫磊', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177463613971664897', '杨茂富', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177463720364380161', '田健', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177463850350055425', '孔令超', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177463974279155713', '陈秋华', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177464165442949121', '王财源', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177464351275782145', '连潇', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177464601830920193', '刘观川', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177464849051586561', '王广扩', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177465033697431553', '范可磊', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177465813330464769', '王威', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177466067329126401', '刘鹏', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177466557085421569', '王杰', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177584646889406464', '蒋中正', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177586415669346304', '嬴政', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177587562169761792', '中华', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177590856959221760', '李世民', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177597844258656256', '田青', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177598119119785984', '孔令', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177599307663904768', '刘彻', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177599745272418304', '李善长', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177600181459062784', '杨茂', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177602504524562432', '李渊000', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177609514229956608', '李世0099', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177610154670817280', '田健000', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177611122229641216', '李世9099', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177615463607033856', '0000', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177616496320163840', '田健9090', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177767294815547392', '李世111', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177770468901240832', '陈秋华000', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177771589883400192', '杨茂999', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177774088505876480', '王财源0000', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177779674039537664', '李世222', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177805585258483712', '9090', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177806924155817984', '李渊', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177953463243214848', '2222', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177958882355281920', '习大大', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177960347136262144', '普京', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177960670621958144', '犯我中华者虽远必诛', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177960981348581376', '强汉', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177962203476492288', '犯我中华者', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177962390907355136', '哪吒', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177964486855589888', '姜子牙', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177964817186390016', '雷震子', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177965123173449728', '帝辛', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177968132926308352', '郭鑫年', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177968412409561088', '罗帷', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177969470292721664', '国立', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177969707426086912', '香山', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1177976658125918208', '申公豹', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178121126816202753', '元始天尊', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178125321665474560', '道德天尊', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178127101400920064', '汉武帝', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178127340094566400', '鸿钧老祖', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178127547435790336', '女娲娘娘', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178128738613932032', '通天教主', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178129076460924929', '赵公明', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178129616213323776', '九龙岛四圣', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178131919641194496', '杨戬', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178218666114805760', '东夷西戎', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1178219095326322688', '犯我强汉者虽远必诛', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1181430786198204416', '啸天犬', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver` VALUES ('1182817501256482816', '西洋蛮夷', NULL, NULL, NULL, NULL, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_driver_department
-- ----------------------------
DROP TABLE IF EXISTS `t_driver_department`;
CREATE TABLE `t_driver_department` (
  `department_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `department_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `department_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `department_date` datetime DEFAULT NULL,
  `t_data_status` int(10) DEFAULT NULL,
  PRIMARY KEY (`department_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_driver_department
-- ----------------------------
BEGIN;
INSERT INTO `t_driver_department` VALUES ('1', '1', '暂无部门', '2019-10-08 12:35:15', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_driver_status
-- ----------------------------
DROP TABLE IF EXISTS `t_driver_status`;
CREATE TABLE `t_driver_status` (
  `driver_status_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '人员状态id',
  `status_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态码',
  `status_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态名称',
  PRIMARY KEY (`driver_status_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_driver_status
-- ----------------------------
BEGIN;
INSERT INTO `t_driver_status` VALUES ('1', '1', '空闲');
INSERT INTO `t_driver_status` VALUES ('2', '2', '任务中');
INSERT INTO `t_driver_status` VALUES ('3', '3', '休息中');
COMMIT;

-- ----------------------------
-- Table structure for t_driver_use_man
-- ----------------------------
DROP TABLE IF EXISTS `t_driver_use_man`;
CREATE TABLE `t_driver_use_man` (
  `t_driver_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用车人id 主键（uuid)',
  `t_use_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用车人姓名',
  `t_department` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所属部门',
  `t_tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
  `t_card_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '身份证号',
  `t_status` int(3) DEFAULT NULL COMMENT '驾驶员状态 0：空闲 1：任务中 2：休息中',
  `t_data_status` int(2) DEFAULT NULL COMMENT '数据状态',
  `t_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`t_driver_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_driver_use_man
-- ----------------------------
BEGIN;
INSERT INTO `t_driver_use_man` VALUES ('117881052473343', '蒋介石', '1', NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver_use_man` VALUES ('117881076506286', '孙中山', '1', NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118142582855592', '蓝玉', '1', NULL, NULL, NULL, 1, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118143078849668', '周树人', '1', NULL, NULL, NULL, 1, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118255149415148', '东西', '1', NULL, NULL, NULL, 0, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118255149418923', '东西', '1', NULL, NULL, NULL, 1, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118255149427731', '东西', '1', NULL, NULL, NULL, 1, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118255149430247', '东西', '1', NULL, NULL, NULL, 1, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118255149436958', '东西', '1', NULL, NULL, NULL, 1, NULL);
INSERT INTO `t_driver_use_man` VALUES ('118281750408763', '好好', '1', NULL, NULL, NULL, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for t_duty
-- ----------------------------
DROP TABLE IF EXISTS `t_duty`;
CREATE TABLE `t_duty` (
  `duty_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '值班id',
  `duty_company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '值班单位',
  `duty_create_date` datetime DEFAULT NULL COMMENT '制表日期',
  `duty_week` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '星期几',
  `duty_date_start` datetime DEFAULT NULL,
  `duty_date_end` datetime DEFAULT NULL,
  `duty_date` date DEFAULT NULL COMMENT '对应的日期',
  `duty_leader` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '值班领导',
  `duty_man` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '值班员',
  PRIMARY KEY (`duty_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_duty
-- ----------------------------
BEGIN;
INSERT INTO `t_duty` VALUES ('1', NULL, '2019-08-29 11:36:27', '星期一', NULL, NULL, '2019-08-26', '刘云民', '刘俊志');
INSERT INTO `t_duty` VALUES ('1166917502365900800', '卫戍区东城第四干休所', '2019-08-29 11:36:27', '星期一', NULL, NULL, '2019-09-02', '刘云民', '曾健文');
INSERT INTO `t_duty` VALUES ('1166917502642724864', '卫戍区东城第四干休所', '2019-08-29 11:36:28', '星期二', NULL, NULL, '2019-09-03', '刘云民', '刘俊志');
INSERT INTO `t_duty` VALUES ('1166917503003435008', '卫戍区东城第四干休所', '2019-08-29 11:36:28', '星期三', NULL, NULL, '2019-09-04', '刘云民', '刘骁磊');
INSERT INTO `t_duty` VALUES ('1166984907411451904', '卫戍区东城第四干休所', '2019-08-29 16:04:18', '星期一', NULL, NULL, '2019-09-02', '刘云民', '曾健文');
INSERT INTO `t_duty` VALUES ('1166984907935739904', '卫戍区东城第四干休所', '2019-08-29 16:04:18', '星期二', NULL, NULL, '2019-09-03', '刘云民', '刘俊志');
INSERT INTO `t_duty` VALUES ('1166984908199981056', '卫戍区东城第四干休所', '2019-08-29 16:04:18', '星期三', NULL, NULL, '2019-09-04', '刘云民', '刘骁磊');
INSERT INTO `t_duty` VALUES ('1166995239222939648', '卫戍区东城第四干休所', '2019-08-29 16:45:21', '星期一', NULL, NULL, '2019-09-02', '刘云民', '曾健文');
INSERT INTO `t_duty` VALUES ('1166995239550095360', '卫戍区东城第四干休所', '2019-08-29 16:45:21', '星期二', NULL, NULL, '2019-09-03', '刘云民', '刘俊志');
INSERT INTO `t_duty` VALUES ('1166995239860473856', '卫戍区东城第四干休所', '2019-08-29 16:45:22', '星期三', NULL, NULL, '2019-09-04', '刘云民', '刘骁磊');
INSERT INTO `t_duty` VALUES ('1167005714933387264', '卫戍区东城第四干休所', '2019-08-29 17:26:59', '星期一', '2019-09-02 08:00:00', '2019-09-02 08:00:00', NULL, '刘云民', '曾健文');
INSERT INTO `t_duty` VALUES ('1167005715239571456', '卫戍区东城第四干休所', '2019-08-29 17:26:59', '星期二', '2019-09-03 08:00:00', '2019-09-03 08:00:00', NULL, '刘云民', '刘俊志');
INSERT INTO `t_duty` VALUES ('1167005715600281600', '卫戍区东城第四干休所', '2019-08-29 17:26:59', '星期三', '2019-09-04 08:00:00', '2019-09-04 08:00:00', NULL, '刘云民', '刘骁磊');
INSERT INTO `t_duty` VALUES ('2', NULL, '2019-08-29 11:36:27', '星期二', NULL, NULL, '2019-08-27', '刘云民', '刘骁磊');
INSERT INTO `t_duty` VALUES ('3', NULL, '2019-08-29 11:36:27', '星期三', NULL, NULL, '2019-08-28', '刘云民', '孙海涛');
INSERT INTO `t_duty` VALUES ('4', NULL, '2019-08-29 11:36:27', '星期四', NULL, NULL, '2019-08-29', '刘云民', '曾健文');
INSERT INTO `t_duty` VALUES ('5', NULL, '2019-08-29 11:36:27', '星期五', NULL, NULL, '2019-08-30', '刘云民', '刘俊志');
INSERT INTO `t_duty` VALUES ('6', NULL, '2019-08-29 11:36:27', '星期六', NULL, NULL, '2019-08-31', '刘云民', '刘骁磊');
INSERT INTO `t_duty` VALUES ('7', NULL, '2019-08-29 11:36:27', '星期日', NULL, NULL, '2019-09-01', '刘云民', '孙海涛');
COMMIT;

-- ----------------------------
-- Table structure for t_matter
-- ----------------------------
DROP TABLE IF EXISTS `t_matter`;
CREATE TABLE `t_matter` (
  `t_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `t_cause` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '事由内容',
  `t_create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `t_data_status` int(11) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`t_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_matter
-- ----------------------------
BEGIN;
INSERT INTO `t_matter` VALUES ('118254936941774', '洪武元年', '2019-10-11 14:51:55', 0);
INSERT INTO `t_matter` VALUES ('118254943253782', '奉天讨元', '2019-10-11 14:52:10', 0);
INSERT INTO `t_matter` VALUES ('118254950551451', '蒙古==恶魔', '2019-10-11 14:52:27', 0);
INSERT INTO `t_matter` VALUES ('118254967935164', '西洋蛮夷==恶魔', '2019-10-11 14:53:09', 0);
INSERT INTO `t_matter` VALUES ('440195643998208', '扫黑恶', '2019-10-08 13:24:27', 1);
INSERT INTO `t_matter` VALUES ('551492649922560', '东北', '2019-10-11 15:00:21', 0);
INSERT INTO `t_matter` VALUES ('551492654116864', '东北', '2019-10-11 15:00:21', 0);
INSERT INTO `t_matter` VALUES ('551492800917504', '东北', '2019-10-11 15:00:21', 0);
INSERT INTO `t_matter` VALUES ('551492830277632', '东北', '2019-10-11 15:00:21', 0);
INSERT INTO `t_matter` VALUES ('551492855443456', '东北', '2019-10-11 15:00:21', 0);
INSERT INTO `t_matter` VALUES ('551492855443457', '东北', '2019-10-11 15:00:21', 0);
INSERT INTO `t_matter` VALUES ('763653094227968', '有黑必扫，有恶必除', '2019-09-28 09:55:11', 0);
INSERT INTO `t_matter` VALUES ('779673892737024', '不忘初心，牢记使命', '2019-09-28 10:58:51', 0);
INSERT INTO `t_matter` VALUES ('817500560228352', '血战洪都', '2019-10-12 08:37:22', 0);
INSERT INTO `t_matter` VALUES ('960347018821632', '听党指挥，能打胜仗，作风优良', '2019-09-28 22:56:47', 0);
COMMIT;

-- ----------------------------
-- Table structure for t_paiche
-- ----------------------------
DROP TABLE IF EXISTS `t_paiche`;
CREATE TABLE `t_paiche` (
  `t_paiche_id` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '派车单id',
  `t_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '单号（流水号）',
  `t_date` datetime DEFAULT NULL COMMENT '开单日期',
  `t_dept_id` int(11) DEFAULT NULL,
  `t_use_man` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用车人',
  `t_cause` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '事由去向',
  `t_man` int(11) DEFAULT NULL COMMENT '人数',
  `t_weight` int(11) DEFAULT NULL COMMENT '载重',
  `t_car_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车号（车辆id)',
  `t_driver_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '驾驶人ID',
  `t_des_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '目的地',
  `t_drive_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '开车时间',
  `t_go_mileage` int(11) DEFAULT NULL COMMENT '出场前里程表指数',
  `t_come_mileage` int(11) DEFAULT NULL COMMENT '回场前里程表指数',
  `t_mileage` int(11) DEFAULT NULL COMMENT '行驶里程',
  `t_com_mander` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '派车人',
  `t_audit_leadership` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核领导',
  `t_return_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '实际回场时间',
  `t_storage_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '实际出场时间',
  `t_guji_reture_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '估计回场时间',
  `t_guji_storage_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '估计出场时间',
  `t_update_time` varchar(0) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新时间',
  `t_data_status` int(2) DEFAULT NULL COMMENT '数据状态 0正常 1删除',
  `t_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `t_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核状态 1取消订单 2正常订单 3已完成',
  `t_car_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`t_paiche_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_paiche
-- ----------------------------
BEGIN;
INSERT INTO `t_paiche` VALUES ('440195618832384', '20191008132427', '2019-10-08 13:24:27', 1, '117881076506286', '440195643998208', NULL, NULL, '117746666706007', '1178121126816202753', '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-26 13:21:33', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '7');
INSERT INTO `t_paiche` VALUES ('544485008125952', '20191011143230', '2019-10-11 14:32:31', 1, '117881076506286', '960347018821632', NULL, NULL, '117746666706007', '1178121126816202753', '54371995861', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 14:31:06', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '9');
INSERT INTO `t_paiche` VALUES ('544887359320064', '20191011143406', '2019-10-11 14:34:07', 1, '117881052473343', '960347018821632', NULL, NULL, '117746666706007', '1178121126816202753', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-26 13:21:33', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '10');
INSERT INTO `t_paiche` VALUES ('545277320540160', '20191011143539', '2019-10-11 14:35:40', 1, '117881076506286', '960347018821632', NULL, NULL, '117746503369743', '1177969707426086912', '54371995861', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-09-27 14:08:35', '2019-08-26 13:21:33', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '11');
INSERT INTO `t_paiche` VALUES ('545465082753024', '20191011143624', '2019-10-11 14:36:24', 1, '117881076506286', '779673892737024', NULL, NULL, '117746503369743', '1177969707426086912', '54371995861', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-09-27 14:08:35', '2019-08-26 13:21:33', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '10');
INSERT INTO `t_paiche` VALUES ('547593977245696', '20191011144452', '2019-10-11 14:44:52', 1, '117881052473343', '960347018821632', NULL, NULL, '117746686464115', '1178218666114805760', '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-26 13:21:33', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '10');
INSERT INTO `t_paiche` VALUES ('548092067622912', '20191011144650', '2019-10-11 14:46:51', 1, '117881076506286', '960347018821632', NULL, NULL, '117746675633583', '1181430786198204416', '54371995861', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 14:46:48', '2019-09-07 00:00:00', NULL, 0, NULL, '3', '9');
INSERT INTO `t_paiche` VALUES ('551460496388096', '20191011150021', '2019-10-11 15:00:22', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551469086322688', '20191011150022', '2019-10-11 15:00:22', 1, '118255149430247', '551492855443457', NULL, NULL, '117746519712848', '1177590856959221760', '551492146606083', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551474375340032', '20191011150022', '2019-10-11 15:00:22', 1, '118255149436958', '551492830277632', NULL, NULL, '117746519712848', '1177590856959221760', '551492146606080', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551480041844736', '20191011150021', '2019-10-11 15:00:22', 1, '118255149418923', '551492800917504', NULL, NULL, '117746519712848', '1177590856959221760', '551492146606081', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551491848810496', '20191011150022', '2019-10-11 15:00:22', 1, '118255149427731', '551492855443456', NULL, NULL, '117746519712848', '1177590856959221760', '551492146606082', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551497662115840', '20191011150023', '2019-10-11 15:00:23', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551498031214592', '20191011150024', '2019-10-11 15:00:24', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551498031214593', '20191011150022', '2019-10-11 15:00:23', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551498102517760', '20191011150022', '2019-10-11 15:00:23', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551498178015232', '20191011150022', '2019-10-11 15:00:23', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551500174503936', '20191011150023', '2019-10-11 15:00:24', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551500426162176', '20191011150023', '2019-10-11 15:00:23', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('551500430356480', '20191011150023', '2019-10-11 15:00:24', 1, '118255149415148', '551492649922560', NULL, NULL, '117746519712848', '1177590856959221760', '551491873976320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-11 17:00:00', '2019-10-11 14:59:25', NULL, 0, NULL, '3', '0');
INSERT INTO `t_paiche` VALUES ('552070188806144', '20191011150239', '2019-10-11 15:02:39', 1, '117881076506286', '551492649922560', NULL, NULL, '117746675633583', '1181430786198204416', '54371995861', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-28 00:00:00', '2019-09-07 00:00:00', NULL, 0, NULL, '2', '9');
INSERT INTO `t_paiche` VALUES ('657981239373824', '20191011220330', '2019-10-11 22:03:30', 1, '118255149415148', '551492649922560', NULL, NULL, '117746666706007', '1178121126816202753', '10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-26 13:21:33', '2019-09-07 00:00:00', NULL, 0, NULL, '2', '10');
INSERT INTO `t_paiche` VALUES ('817499993997312', '20191012083723', '2019-10-12 08:37:24', 1, '118281750408763', '817500560228352', NULL, NULL, '117746686464115', '1182817501256482816', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-19 00:00:00', '2019-10-12 08:37:17', NULL, 0, NULL, '2', '7');
COMMIT;

-- ----------------------------
-- Table structure for t_paiche_car_driver
-- ----------------------------
DROP TABLE IF EXISTS `t_paiche_car_driver`;
CREATE TABLE `t_paiche_car_driver` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '派车车辆表id',
  `t_paiche_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '派车单id',
  `t_car_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车辆id',
  `t_driver_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_paiche_car_driver
-- ----------------------------
BEGIN;
INSERT INTO `t_paiche_car_driver` VALUES ('1', '1161229875537645568', '504456462802944', NULL);
INSERT INTO `t_paiche_car_driver` VALUES ('10', '200635453284352', '354389423931392', '116145581747232');
COMMIT;

-- ----------------------------
-- Table structure for t_paiche_driver
-- ----------------------------
DROP TABLE IF EXISTS `t_paiche_driver`;
CREATE TABLE `t_paiche_driver` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '派车驾驶员表id',
  `t_paiche_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '派车单id',
  `t_driver_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '驾驶员id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_paiche_driver
-- ----------------------------
BEGIN;
INSERT INTO `t_paiche_driver` VALUES ('1', '1161229875537645568', '506809953865728');
COMMIT;

-- ----------------------------
-- Table structure for t_per
-- ----------------------------
DROP TABLE IF EXISTS `t_per`;
CREATE TABLE `t_per` (
  `t_per_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限id',
  `t_per_num` int(2) NOT NULL,
  `t_per_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`t_per_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_per
-- ----------------------------
BEGIN;
INSERT INTO `t_per` VALUES ('1', 0, '管理员');
INSERT INTO `t_per` VALUES ('2', 1, '操作员');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户表主键',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `t_data_status` int(2) DEFAULT NULL COMMENT '数据状态',
  `t_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `t_per` int(2) DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1', '1', '1', 'e10adc3949ba59abbe56e057f20f883e', 0, '1', 1);
INSERT INTO `t_user` VALUES ('1161842717475389440', '123', '操作员1', '202cb962ac59075b964b07152d234b70', 0, '操作员1', 2);
INSERT INTO `t_user` VALUES ('449602402295808', 'admin', '系统管理员', 'e10adc3949ba59abbe56e057f20f883e', 0, '系统管理员', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
